* Rep_11-year Reintervention Analysis supplement 2.sps.
* Written by PSKL on 2/4/03.

Get file = 'D:\Longitudinal Data\Rep_Descriptive Data 1991 to 2001.sav'
 /keep patidn quadrant tooth claimidn doplacn maintrt filled time reptreat reint yearplac.

select if (reint=1).

compute timew= trunc(time/7).

compute timelm= trunc(time/28).

Recode maintrt reptreat
 (1401 thru 1411 = 1)
 (1421 = 2)
 (1426,5836 = 3)
 (1501 thru 1531,5841,6301 thru 6351 = 4)
 (1701 thru 1782, 5111,5112,6501 thru 6523 = 5)
 (2101 thru 2205, 5201 thru 5214 = 6)
 (2733 thru 2863 = 7)
 (1601,6401,1801 thru 1832,6301,9999  = 8)
 into trtgrp reintgrp.

Variable Labels reintgrp 'Type of Reintervention'.
Value Labels reintgrp
1 'Amalgam'
2 'Resin Composite'
3 'Glass Ionomer'
4 'Root filling plus non direct'
5 'Crowns/Inlays'
6 'Extractions'
7 'Dentures'
8 'Other'.

* Restrict to glass ionomers placed between 1994 and 1996 inclusive.

select if (range(yearplac,1994,1996) and trtgrp=3).

CROSSTABS
  /TABLES=timelm BY reintgrp
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT.

Crosstabs

**Notes**
Output Created		11-JUN-2003 16:05:51
Comments
Input	Filter	<none>
	Weight	<none>
	Split File	<none>
	N of Rows in Working Data File	7910
Missing Value Handling	Definition of Missing	User-defined missing values are treated as missing.
Missing Value Handling	Cases Used	Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax		CROSSTABS /TABLES=timelm BY reintgrp /FORMAT= AVALUE TABLES /CELLS= COUNT.
Resources	Dimensions Requested	2
	Cells Available	116508
	Elapsed Time	0:00:18.37

**Case Processing Summary**
	Cases
	Valid		Missing		Total
	N	Percent	N	Percent	N	Percent
TIMELM * Type of Reintervention	7910	100.0%	0	.0%	7910	100.0%

**TIMELM * Type of Reintervention Crosstabulation**
Count
		Type of Reintervention								Total
		Amalgam	Resin Composite	Glass Ionomer	Root filling plus non direct	Crowns/Inlays	Extractions	Dentures	Other	Total
TIMELM	.00	37	18	52	10	34	36	4	4	195
	1.00	40	27	68	8	27	31	4		205
	2.00	41	20	62	8	25	24	5	1	186
	3.00	48	15	56	4	22	22	5	3	175
	4.00	31	29	53	5	15	24		1	158
	5.00	41	22	89	5	22	16	2	3	200
	6.00	59	40	160	4	21	24	8	2	318
	7.00	59	58	102	5	21	25	3		273
	8.00	43	28	67	1	20	15	5	3	182
	9.00	34	38	64	3	18	17	2		176
	10.00	43	27	62	3	11	17	3	1	167
	11.00	34	24	53	2	6	13	4		136
	12.00	27	39	77	6	23	26	4		202
	13.00	42	53	94	3	12	22	1	3	230
	14.00	38	42	69	3	15	13	3	1	184
	15.00	36	27	54	5	18	16	4	2	162
	16.00	28	18	53	1	16	12	3		131
	17.00	29	33	38	2	13	9	4		128
	18.00	28	15	34	5	8	12	3	2	107
	19.00	36	23	72	4	14	9	3		161
	20.00	26	23	58	2	6	17	2	1	135
	21.00	28	23	55	3	6	10	1		126
	22.00	28	31	42	1	4	12	2	2	122
	23.00	24	30	48	3	8	18	1	1	133
	24.00	27	25	36	3	4	10	4		109
	25.00	33	15	44	3	5	10	4	1	115
	26.00	23	21	50	4	7	2	1	1	109
	27.00	31	26	34		6	10	3	3	113
	28.00	25	23	41	2	12	6	4		113
	29.00	27	19	31	3	6	9	1	1	97
	30.00	17	23	32	1	4	9	2		88
	31.00	14	30	27		4	12	5		92
	32.00	19	34	42		6	4	1		106
	33.00	27	24	28		6	11	1		97
	34.00	14	18	33	1	5	9	3	1	84
	35.00	20	16	39	1	3	12			91
	36.00	12	22	20	1	5	7			67
	37.00	14	19	25	1	5	14	2		80
	38.00	19	13	22	1	3	12	1	1	72
	39.00	10	21	28	2	2	7			70
	40.00	20	25	15		7	9	2	1	79
	41.00	17	20	31	1	4	9	2	1	85
	42.00	23	27	19	1	4	3	1	2	80
	43.00	16	26	21	2	3	6	2		76
	44.00	19	15	19	1	7	5			66
	45.00	11	23	22	1	5	5	2		69
	46.00	11	19	25	1	5	9	2	2	74
	47.00	8	17	24	2	4	6	2	1	64
	48.00	19	17	18	1	4	11		2	72
	49.00	15	19	21		1	8	1	1	66
	50.00	23	18	16		2	4	4	2	69
	51.00	11	19	14		5	6	1	1	57
	52.00	16	15	15	1	4	2	1		54
	53.00	17	13	10	2	4	3	1		50
	54.00	17	10	15	1	6	7	2		58
	55.00	10	17	18	1	2	4	2	1	55
	56.00	10	10	14	3	6	1	1		45
	57.00	9	12	9	1	6	7	2	1	47
	58.00	14	6	9	2	1	6	2		40
	59.00	9	12	14		1	3	3	1	43
	60.00	5	19	12	1	2	1	4		44
	61.00	10	20	10		4	3	1		48
	62.00	8	24	13	2	2	11		1	61
	63.00	6	14	10		3	3	2	1	39
64.00	10	8	8		4	9		1	40
65.00	11	17	11	1	4	5	1		50
66.00	9	9	8		4	7	1		38
67.00	6	12	7	1	2	6	3	2	39
68.00	11	12	11		3	5	2		44
69.00	11	14	10	1	2	4	1		43
70.00	12	10	8	1		5		1	37
71.00	7	9	17	3	5	6	2		49
72.00	10	9	7			7		2	35
73.00	4	11	4			1	2		22
74.00	14	8	5			5	1		33
75.00	2	13	7	1	4	3			30
76.00	3	4	6	1	1	5			20
77.00	2	11	3	1		2			19
78.00	3	8	4	2		2			19
79.00	3	14	3		1	5			26
80.00	2	10	4		1	2	3		22
81.00	6	4	7	1	2	2	1		23
82.00	3	11	2			2			18
83.00	3	5	3			1	1		13
84.00	4	1	7	1			1		14
85.00	2	5	3	1	1	4			16
86.00	4	6			2	1	1		14
87.00	4	6	3	2	1	2			18
88.00		2	3		2	1	2		10
89.00	2	4	1		1	2			10
90.00	3	5	5	1	1				15
91.00	3	4	1			1			9
92.00	5	1	5		1	2	1		15
93.00	1	1	2	1					5
94.00	1	2	1		1	1			6
95.00	3	7	2			1			13
96.00		1	1						2
98.00			1					1	2
99.00		2							2
101.00						1			1
102.00		2							2
Total		1700	1717	2678	162	603	816	171	63	7910